package com.ruoyi.StarStudio.Mapper;

import com.ruoyi.StarStudio.Domain.MainZone;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

@Mapper
public interface MainZoneMapper {

    @Select("select * from mainzone")
    public MainZone get();

    @Insert("insert into mainzone  values (null, #{mainZone_name}, #{mainZone_location}, #{mainZone_area}, #{mainZone_agricultural_area}, #{mainZone_planting_area}, #{mainZone_introduction},#{mainZone_level},#{mainZone_viewpoint},#{mainZone_culture})")
    public boolean add(MainZone mainzone);

    @Update("update mainzone set mainZone_name=#{mainZone_name},mainZone_location=#{mainZone_location},mainZone_area = #{mainZone_area}, mainZone_agricultural_area=#{mainZone_agricultural_area},mainZone_planting_area=#{mainZone_planting_area},mainZone_introduction=#{mainZone_introduction}," +
            "mainZone_level=#{mainZone_level},mainZone_viewpoint=#{mainZone_viewpoint},mainZone_culture=#{mainZone_culture}")
    public boolean update(MainZone updateMainZone);

}
